2025-04-02 03:22:57,747 [ 591352 ] INFO : ClickHouse root is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse (runner:53, check_args_and_update_paths) 2025-04-02 03:22:57,747 [ 591352 ] INFO : Cases dir is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration (runner:97, check_args_and_update_paths) 2025-04-02 03:22:57,747 [ 591352 ] INFO : utils dir is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse/utils (runner:108, check_args_and_update_paths) 2025-04-02 03:22:57,748 [ 591352 ] INFO : base_configs_dir: /home/ubuntu/_work/ClickHouse/ClickHouse/programs/server, binary: /home/ubuntu/_work/_temp/test/build/clickhouse, cases_dir: /home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration (runner:110, check_args_and_update_paths) clickhouse_integration_tests_volume Running pytest container as: 'docker run --rm --name clickhouse_integration_tests_xfw36y --privileged --dns-search='.' --memory=30709030912 --security-opt seccomp=unconfined --cap-add=SYS_PTRACE --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-odbc-bridge:/clickhouse-odbc-bridge --volume=/home/ubuntu/_work/_temp/test/build/clickhouse:/clickhouse --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-library-bridge:/clickhouse-library-bridge --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/programs/server:/clickhouse-config --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration:/ClickHouse/tests/integration --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/backupview:/ClickHouse/utils/backupview --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/grpc-client/pb2:/ClickHouse/utils/grpc-client/pb2 --volume=/run:/run/host:ro --volume=clickhouse_integration_tests_volume:/var/lib/docker -e DOCKER_DOTNET_CLIENT_TAG=11de0b29a15d -e DOCKER_HELPER_TAG=5dc43a6382f0 -e DOCKER_BASE_TAG=8b2301119731 -e DOCKER_KERBEROS_KDC_TAG=9391ecdee8d7 -e DOCKER_MYSQL_GOLANG_CLIENT_TAG=9bec2a638e6e -e DOCKER_MYSQL_JAVA_CLIENT_TAG=766bff31cfe4 -e DOCKER_MYSQL_JS_CLIENT_TAG=41ba7c2ec2a1 -e DOCKER_MYSQL_PHP_CLIENT_TAG=88be89c1e3b6 -e DOCKER_NGINX_DAV_TAG=b55ac9cd7519 -e DOCKER_POSTGRESQL_JAVA_CLIENT_TAG=a4eff5c7f4d6 -e DOCKER_PYTHON_BOTTLE_TAG=caad4729259e -e DOCKER_CLIENT_TIMEOUT=300 -e COMPOSE_HTTP_TIMEOUT=600 -e PYTHONUNBUFFERED=1 -e PYTEST_ADDOPTS=" -rfEps --run-id=2 --color=no --durations=0 test_mask_sensitive_info/test.py::test_create_table test_mask_sensitive_info/test.py::test_table_functions -vvv -ss" altinityinfra/integration-tests-runner:2165613c5fcd '. Start tests ============================= test session starts ============================== platform linux -- Python 3.10.12, pytest-7.4.4, pluggy-1.5.0 -- /usr/bin/python3 cachedir: .pytest_cache Test order randomisation NOT enabled. Enable with --random-order or --random-order-bucket= rootdir: /ClickHouse/tests/integration configfile: pytest.ini plugins: timeout-2.3.1, repeat-0.9.3, order-1.0.0, reportlog-0.4.0, xdist-3.5.0, random-order-1.1.1 timeout: 900.0s timeout method: signal timeout func_only: False collecting ... collected 2 items test_mask_sensitive_info/test.py::test_create_table Copy common default production configuration from /clickhouse-config. Files: config.xml, users.xml FAILED test_mask_sensitive_info/test.py::test_table_functions FAILED =================================== FAILURES =================================== ______________________________ test_create_table _______________________________ def test_create_table(): password = new_password() azure_conn_string = cluster.env_variables["AZURITE_CONNECTION_STRING"] account_key_pattern = re.compile("AccountKey=.*?(;|$)") masked_azure_conn_string = re.sub( account_key_pattern, "AccountKey=[HIDDEN]\\1", azure_conn_string ) azure_storage_account_url = cluster.env_variables["AZURITE_STORAGE_ACCOUNT_URL"] azure_account_name = "devstoreaccount1" azure_account_key = "Eby8vdM02xNOcqFlqUwJPLlmEtlCDXJ1OUzFT50uSRZ6IFsuFq2UVErCz4I6tq/K1SZFPTOtr/KBHBeksoGMGw==" table_engines = [ f"MySQL('mysql80:3306', 'mysql_db', 'mysql_table', 'mysql_user', '{password}')", f"PostgreSQL('postgres1:5432', 'postgres_db', 'postgres_table', 'postgres_user', '{password}')", f"MongoDB('mongo1:27017', 'mongo_db', 'mongo_col', 'mongo_user', '{password}')", f"S3('http://minio1:9001/root/data/test1.csv')", f"S3('http://minio1:9001/root/data/test2.csv', 'CSV')", f"S3('http://minio1:9001/root/data/test3.csv.gz', 'CSV', 'gzip')", f"S3('http://minio1:9001/root/data/test4.csv', 'minio', '{password}', 'CSV')", f"S3('http://minio1:9001/root/data/test5.csv.gz', 'minio', '{password}', 'CSV', 'gzip')", f"MySQL(named_collection_1, host = 'mysql80', port = 3306, database = 'mysql_db', table = 'mysql_table', user = 'mysql_user', password = '{password}')", f"MySQL(named_collection_2, database = 'mysql_db', host = 'mysql80', port = 3306, password = '{password}', table = 'mysql_table', user = 'mysql_user')", f"MySQL(named_collection_3, database = 'mysql_db', host = 'mysql80', port = 3306, table = 'mysql_table')", f"PostgreSQL(named_collection_4, host = 'postgres1', port = 5432, database = 'postgres_db', table = 'postgres_table', user = 'postgres_user', password = '{password}')", f"MongoDB(named_collection_5, host = 'mongo1', port = 5432, database = 'mongo_db', collection = 'mongo_col', user = 'mongo_user', password = '{password}')", f"S3(named_collection_6, url = 'http://minio1:9001/root/data/test8.csv', access_key_id = 'minio', secret_access_key = '{password}', format = 'CSV')", f"S3('http://minio1:9001/root/data/test9.csv.gz', 'NOSIGN', 'CSV', 'gzip')", f"S3('http://minio1:9001/root/data/test10.csv.gz', 'minio', '{password}')", ( f"DeltaLake('http://minio1:9001/root/data/test11.csv.gz', 'minio', '{password}')", "DNS_ERROR", ), f"S3Queue('http://minio1:9001/root/data/', 'CSV') settings mode = 'ordered'", f"S3Queue('http://minio1:9001/root/data/', 'CSV', 'gzip') settings mode = 'ordered'", f"S3Queue('http://minio1:9001/root/data/', 'minio', '{password}', 'CSV') settings mode = 'ordered'", f"S3Queue('http://minio1:9001/root/data/', 'minio', '{password}', 'CSV', 'gzip') settings mode = 'ordered'", ( f"Iceberg('http://minio1:9001/root/data/test11.csv.gz', 'minio', '{password}')", "DNS_ERROR", ), ( f"IcebergS3('http://minio1:9001/root/data/test11.csv.gz', 'minio', '{password}')", "DNS_ERROR", ), f"AzureBlobStorage('{azure_conn_string}', 'cont', 'test_simple.csv', 'CSV')", f"AzureBlobStorage('{azure_conn_string}', 'cont', 'test_simple_1.csv', 'CSV', 'none')", f"AzureBlobStorage('{azure_storage_account_url}', 'cont', 'test_simple_2.csv', '{azure_account_name}', '{azure_account_key}')", f"AzureBlobStorage('{azure_storage_account_url}', 'cont', 'test_simple_3.csv', '{azure_account_name}', '{azure_account_key}', 'CSV')", f"AzureBlobStorage('{azure_storage_account_url}', 'cont', 'test_simple_4.csv', '{azure_account_name}', '{azure_account_key}', 'CSV', 'none')", ] def make_test_case(i): table_name = f"table{i}" table_engine = table_engines[i] error = None if isinstance(table_engine, tuple): table_engine, error = table_engine query = f"CREATE TABLE {table_name} (x int) ENGINE = {table_engine}" return table_name, query, error # Generate test cases as a list of tuples (table_name, query, error). test_cases = [make_test_case(i) for i in range(len(table_engines))] for table_name, query, error in test_cases: if error: > assert error in node.query_and_get_error(query) E assert 'DNS_ERROR' in "Received exception from server (version 25.2.2):\nCode: 56. DB::Exception: Received from 172.16.1.6:9000. DB::Exception: Unknown table engine DeltaLake. Stack trace:\n\n0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000cfb8fbb\n1. DB::Exception::Exception(PreformattedMessage&&, int) @ 0x0000000007ff830c\n2. DB::Exception::Exception(int, FormatStringHelperImpl::type>, String&) @ 0x000000000800e20b\n3. DB::StorageFactory::get(DB::ASTCreateQuery const&, String const&, std::shared_ptr, std::shared_ptr, DB::ColumnsDescription const&, DB::ConstraintsDescription const&, DB::LoadingStrictnessLevel) const @ 0x00000000119e456f\n4. DB::InterpreterCreateQuery::doCreateTable(DB::ASTCreateQuery&, DB::InterpreterCreateQuery::TableProperties const&, std::unique_ptr>&, DB::LoadingStrictnessLevel) @ 0x0000000010f933c4\n5. DB::InterpreterCreateQuery::createTable(DB::ASTCreateQuery&) @ 0x0000000010f886a2\n6. DB::InterpreterCreateQuery::execute() @ 0x0000000010f9b6d8\n7. DB::executeQueryImpl(char const*, char const*, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*, std::shared_ptr&) @ 0x00000000113d6b42\n8. DB::executeQuery(String const&, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x00000000113d1d04\n9. DB::TCPHandler::runImpl() @ 0x000000001270804c\n10. DB::TCPHandler::run() @ 0x00000000127264d9\n11. Poco::Net::TCPServerConnection::start() @ 0x0000000015dda567\n12. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015dda9b9\n13. Poco::PooledThread::run() @ 0x0000000015da6d3b\n14. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015da521d\n15. ? @ 0x00007f479b080ac3\n16. ? @ 0x00007f479b112850\n. (UNKNOWN_STORAGE)\n(query: CREATE TABLE table16 (x int) ENGINE = DeltaLake('http://minio1:9001/root/data/test11.csv.gz', 'minio', 'I2TIDFZV9JPX8XSX'))\n" E + where "Received exception from server (version 25.2.2):\nCode: 56. DB::Exception: Received from 172.16.1.6:9000. DB::Exception: Unknown table engine DeltaLake. Stack trace:\n\n0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000cfb8fbb\n1. DB::Exception::Exception(PreformattedMessage&&, int) @ 0x0000000007ff830c\n2. DB::Exception::Exception(int, FormatStringHelperImpl::type>, String&) @ 0x000000000800e20b\n3. DB::StorageFactory::get(DB::ASTCreateQuery const&, String const&, std::shared_ptr, std::shared_ptr, DB::ColumnsDescription const&, DB::ConstraintsDescription const&, DB::LoadingStrictnessLevel) const @ 0x00000000119e456f\n4. DB::InterpreterCreateQuery::doCreateTable(DB::ASTCreateQuery&, DB::InterpreterCreateQuery::TableProperties const&, std::unique_ptr>&, DB::LoadingStrictnessLevel) @ 0x0000000010f933c4\n5. DB::InterpreterCreateQuery::createTable(DB::ASTCreateQuery&) @ 0x0000000010f886a2\n6. DB::InterpreterCreateQuery::execute() @ 0x0000000010f9b6d8\n7. DB::executeQueryImpl(char const*, char const*, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*, std::shared_ptr&) @ 0x00000000113d6b42\n8. DB::executeQuery(String const&, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x00000000113d1d04\n9. DB::TCPHandler::runImpl() @ 0x000000001270804c\n10. DB::TCPHandler::run() @ 0x00000000127264d9\n11. Poco::Net::TCPServerConnection::start() @ 0x0000000015dda567\n12. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015dda9b9\n13. Poco::PooledThread::run() @ 0x0000000015da6d3b\n14. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015da521d\n15. ? @ 0x00007f479b080ac3\n16. ? @ 0x00007f479b112850\n. (UNKNOWN_STORAGE)\n(query: CREATE TABLE table16 (x int) ENGINE = DeltaLake('http://minio1:9001/root/data/test11.csv.gz', 'minio', 'I2TIDFZV9JPX8XSX'))\n" = >("CREATE TABLE table16 (x int) ENGINE = DeltaLake('http://minio1:9001/root/data/test11.csv.gz', 'minio', 'I2TIDFZV9JPX8XSX')") E + where > = .query_and_get_error test_mask_sensitive_info/test.py:297: AssertionError ------------------------------ Captured log setup ------------------------------ 2025-04-02 03:23:02 [ 665 ] DEBUG : Command:[docker ps | wc -l] (cluster.py:120, run_and_check) 2025-04-02 03:23:02 [ 665 ] DEBUG : Stdout:1 (cluster.py:144, run_and_check) 2025-04-02 03:23:02 [ 665 ] DEBUG : No running containers (conftest.py:95, cleanup_environment) 2025-04-02 03:23:02 [ 665 ] DEBUG : Pruning Docker networks (conftest.py:97, cleanup_environment) 2025-04-02 03:23:02 [ 665 ] DEBUG : Command:[docker network prune --force] (cluster.py:120, run_and_check) 2025-04-02 03:23:02 [ 665 ] DEBUG : Command:[sysctl net.ipv4.ip_local_port_range='55000 65535'] (cluster.py:120, run_and_check) 2025-04-02 03:23:02 [ 665 ] DEBUG : Stdout:net.ipv4.ip_local_port_range = 55000 65535 (cluster.py:144, run_and_check) 2025-04-02 03:23:02 [ 665 ] INFO : Running tests in /ClickHouse/tests/integration/test_mask_sensitive_info/test.py (cluster.py:2677, start) 2025-04-02 03:23:02 [ 665 ] DEBUG : Cluster start called. is_up=False (cluster.py:2684, start) 2025-04-02 03:23:02 [ 665 ] DEBUG : Docker networks for project roottestmasksensitiveinfo are NETWORK ID NAME DRIVER SCOPE (cluster.py:855, print_all_docker_pieces) 2025-04-02 03:23:02 [ 665 ] DEBUG : Docker containers for project roottestmasksensitiveinfo are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:863, print_all_docker_pieces) 2025-04-02 03:23:02 [ 665 ] DEBUG : Docker volumes for project roottestmasksensitiveinfo are DRIVER VOLUME NAME (cluster.py:871, print_all_docker_pieces) 2025-04-02 03:23:02 [ 665 ] DEBUG : Cleanup called (cluster.py:876, cleanup) 2025-04-02 03:23:02 [ 665 ] DEBUG : Docker networks for project roottestmasksensitiveinfo are NETWORK ID NAME DRIVER SCOPE (cluster.py:855, print_all_docker_pieces) 2025-04-02 03:23:02 [ 665 ] DEBUG : Docker containers for project roottestmasksensitiveinfo are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:863, print_all_docker_pieces) 2025-04-02 03:23:02 [ 665 ] DEBUG : Docker volumes for project roottestmasksensitiveinfo are DRIVER VOLUME NAME (cluster.py:871, print_all_docker_pieces) 2025-04-02 03:23:02 [ 665 ] DEBUG : Command:[docker container list --all --filter name='^/roottestmasksensitiveinfo-.*-1$' --format '{{.ID}}:{{.Names}}'] (cluster.py:120, run_and_check) 2025-04-02 03:23:02 [ 665 ] DEBUG : Unstopped containers: {} (cluster.py:890, cleanup) 2025-04-02 03:23:02 [ 665 ] DEBUG : No running containers for project: roottestmasksensitiveinfo (cluster.py:904, cleanup) 2025-04-02 03:23:02 [ 665 ] DEBUG : Trying to prune unused networks... (cluster.py:910, cleanup) 2025-04-02 03:23:02 [ 665 ] DEBUG : Trying to prune unused images... (cluster.py:926, cleanup) 2025-04-02 03:23:02 [ 665 ] DEBUG : Command:[docker image prune -f] (cluster.py:120, run_and_check) 2025-04-02 03:23:02 [ 665 ] DEBUG : Stdout:Total reclaimed space: 0B (cluster.py:144, run_and_check) 2025-04-02 03:23:02 [ 665 ] DEBUG : Images pruned (cluster.py:929, cleanup) 2025-04-02 03:23:02 [ 665 ] DEBUG : Trying to prune unused volumes... (cluster.py:935, cleanup) 2025-04-02 03:23:02 [ 665 ] DEBUG : Command:[docker volume ls | wc -l] (cluster.py:120, run_and_check) 2025-04-02 03:23:02 [ 665 ] DEBUG : Stdout:1 (cluster.py:144, run_and_check) 2025-04-02 03:23:02 [ 665 ] DEBUG : Volumes pruned: 1 (cluster.py:940, cleanup) 2025-04-02 03:23:02 [ 665 ] DEBUG : Setup directory for instance: node (cluster.py:2697, start) 2025-04-02 03:23:02 [ 665 ] DEBUG : Create directory for configuration generated in this helper (cluster.py:4530, create_dir) 2025-04-02 03:23:02 [ 665 ] DEBUG : Create directory for common tests configuration (cluster.py:4535, create_dir) 2025-04-02 03:23:02 [ 665 ] DEBUG : Copy common configuration from helpers (cluster.py:4555, create_dir) 2025-04-02 03:23:02 [ 665 ] DEBUG : Generate and write macros file (cluster.py:4607, create_dir) 2025-04-02 03:23:02 [ 665 ] DEBUG : Copy custom test config files ['/ClickHouse/tests/integration/test_mask_sensitive_info/configs/overrides.xml'] to /ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/node/configs/config.d (cluster.py:4643, create_dir) 2025-04-02 03:23:02 [ 665 ] DEBUG : Setup database dir /ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/node/database (cluster.py:4660, create_dir) 2025-04-02 03:23:02 [ 665 ] DEBUG : Setup logs dir /ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/node/logs (cluster.py:4671, create_dir) 2025-04-02 03:23:02 [ 665 ] DEBUG : Entrypoint cmd: ["clickhouse", "server", "--config-file=/etc/clickhouse-server/config.xml", "--log-file=/var/log/clickhouse-server/clickhouse-server.log", "--errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log", "--"] (cluster.py:4752, create_dir) 2025-04-02 03:23:02 [ 665 ] DEBUG : Env {'ASAN_OPTIONS': 'use_sigaltstack=0', 'TSAN_OPTIONS': 'use_sigaltstack=0', 'CLICKHOUSE_WATCHDOG_ENABLE': '0', 'CLICKHOUSE_NATS_TLS_SECURE': '0', 'LLVM_PROFILE_FILE': '/var/lib/clickhouse/server_%h_%p_%m.profraw', 'keeper_binary': '/clickhouse', 'keeper_cmd_prefix': 'clickhouse keeper', 'image': 'altinityinfra/integration-test:8b2301119731', 'user': '0', 'keeper_fs': 'bind', 'keeper_logs_dir1': '/ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/keeper1/log', 'keeper_config_dir1': '/ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/keeper1/config', 'keeper_db_dir1': '/ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/keeper1/coordination', 'keeper_logs_dir2': '/ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/keeper2/log', 'keeper_config_dir2': '/ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/keeper2/config', 'keeper_db_dir2': '/ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/keeper2/coordination', 'keeper_logs_dir3': '/ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/keeper3/log', 'keeper_config_dir3': '/ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/keeper3/config', 'keeper_db_dir3': '/ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/keeper3/coordination', 'AZURITE_PORT': '30000', 'AZURITE_STORAGE_ACCOUNT_URL': 'http://azurite1:30000/devstoreaccount1', 'AZURITE_CONNECTION_STRING': 'DefaultEndpointsProtocol=http;AccountName=devstoreaccount1;AccountKey=Eby8vdM02xNOcqFlqUwJPLlmEtlCDXJ1OUzFT50uSRZ6IFsuFq2UVErCz4I6tq/K1SZFPTOtr/KBHBeksoGMGw==;BlobEndpoint=http://azurite1:30000/devstoreaccount1;'} stored in /ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/.env (cluster.py:95, _create_env_file) 2025-04-02 03:23:02 [ 665 ] DEBUG : Trying paths: ['/root/.docker/config.json', '/root/.dockercfg'] (config.py:21, find_config_file) 2025-04-02 03:23:02 [ 665 ] DEBUG : No config file found (config.py:28, find_config_file) 2025-04-02 03:23:02 [ 665 ] DEBUG : Trying paths: ['/root/.docker/config.json', '/root/.dockercfg'] (config.py:21, find_config_file) 2025-04-02 03:23:02 [ 665 ] DEBUG : No config file found (config.py:28, find_config_file) 2025-04-02 03:23:02 [ 665 ] DEBUG : http://localhost:None "GET /version HTTP/1.1" 200 826 (connectionpool.py:547, _make_request) 2025-04-02 03:23:02 [ 665 ] DEBUG : Command:[docker compose --env-file /ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/.env --project-name roottestmasksensitiveinfo --file /ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/node/docker-compose.yml --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_keeper.yml --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_azurite.yml pull] (cluster.py:120, run_and_check) 2025-04-02 03:24:03 [ 665 ] DEBUG : Stderr: node Skipped - Image is already being pulled by zoo1 (cluster.py:146, run_and_check) 2025-04-02 03:24:03 [ 665 ] DEBUG : Stderr: zoo2 Skipped - Image is already being pulled by zoo1 (cluster.py:146, run_and_check) 2025-04-02 03:24:03 [ 665 ] DEBUG : Stderr: zoo3 Skipped - Image is already being pulled by zoo1 (cluster.py:146, run_and_check) 2025-04-02 03:24:03 [ 665 ] DEBUG : Stderr: zoo1 Pulling (cluster.py:146, run_and_check) 2025-04-02 03:24:03 [ 665 ] DEBUG : Stderr: azurite1 Pulling (cluster.py:146, run_and_check) 2025-04-02 03:24:03 [ 665 ] DEBUG : Stderr: zoo1 Pulled (cluster.py:146, run_and_check) 2025-04-02 03:24:03 [ 665 ] DEBUG : Stderr: azurite1 Pulled (cluster.py:146, run_and_check) 2025-04-02 03:24:03 [ 665 ] DEBUG : Setup ZooKeeper (cluster.py:2738, start) 2025-04-02 03:24:03 [ 665 ] DEBUG : Creating internal ZooKeeper dirs: ['/ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/keeper1/log', '/ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/keeper1/config', '/ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/keeper1/coordination', '/ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/keeper2/log', '/ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/keeper2/config', '/ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/keeper2/coordination', '/ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/keeper3/log', '/ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/keeper3/config', '/ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/keeper3/coordination'] (cluster.py:2739, start) 2025-04-02 03:24:03 [ 665 ] DEBUG : Command:[docker compose --project-name roottestmasksensitiveinfo --env-file /ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/.env --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_keeper.yml --verbose up -d] (cluster.py:120, run_and_check) 2025-04-02 03:24:04 [ 665 ] DEBUG : Stderr:time="2025-04-02T03:24:03Z" level=trace msg="Docker Desktop integration not enabled" (cluster.py:146, run_and_check) 2025-04-02 03:24:04 [ 665 ] DEBUG : Stderr: Network roottestmasksensitiveinfo_default Creating (cluster.py:146, run_and_check) 2025-04-02 03:24:04 [ 665 ] DEBUG : Stderr: Network roottestmasksensitiveinfo_default Created (cluster.py:146, run_and_check) 2025-04-02 03:24:04 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-zoo3-1 Creating (cluster.py:146, run_and_check) 2025-04-02 03:24:04 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-zoo2-1 Creating (cluster.py:146, run_and_check) 2025-04-02 03:24:04 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-zoo1-1 Creating (cluster.py:146, run_and_check) 2025-04-02 03:24:04 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-zoo3-1 Created (cluster.py:146, run_and_check) 2025-04-02 03:24:04 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-zoo1-1 Created (cluster.py:146, run_and_check) 2025-04-02 03:24:04 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-zoo2-1 Created (cluster.py:146, run_and_check) 2025-04-02 03:24:04 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-zoo2-1 Starting (cluster.py:146, run_and_check) 2025-04-02 03:24:04 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-zoo3-1 Starting (cluster.py:146, run_and_check) 2025-04-02 03:24:04 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-zoo1-1 Starting (cluster.py:146, run_and_check) 2025-04-02 03:24:04 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-zoo3-1 Started (cluster.py:146, run_and_check) 2025-04-02 03:24:04 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-zoo2-1 Started (cluster.py:146, run_and_check) 2025-04-02 03:24:04 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-zoo1-1 Started (cluster.py:146, run_and_check) 2025-04-02 03:24:04 [ 665 ] DEBUG : Stderr:time="2025-04-02T03:24:04Z" level=debug msg="otel error" error="" (cluster.py:146, run_and_check) 2025-04-02 03:24:04 [ 665 ] DEBUG : Stderr:time="2025-04-02T03:24:04Z" level=debug msg="otel error" error="" (cluster.py:146, run_and_check) 2025-04-02 03:24:04 [ 665 ] DEBUG : Wait ZooKeeper to start (cluster.py:2403, wait_zookeeper_to_start) 2025-04-02 03:24:04 [ 665 ] DEBUG : get_instance_ip instance_name=zoo1 (cluster.py:2004, get_instance_ip) 2025-04-02 03:24:04 [ 665 ] DEBUG : http://localhost:None "GET /v1.46/containers/roottestmasksensitiveinfo-zoo1-1/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-04-02 03:24:04 [ 665 ] DEBUG : get_kazoo_client: zoo1, ip:172.16.1.4, port:2181, use_ssl:False (cluster.py:3223, get_kazoo_client) 2025-04-02 03:24:04 [ 665 ] INFO : Connecting to 172.16.1.4(172.16.1.4):2181, use_ssl: False (connection.py:650, _connect) 2025-04-02 03:24:04 [ 665 ] WARNING : Connection dropped: socket connection error: Connection refused (connection.py:622, _connect_attempt) 2025-04-02 03:24:04 [ 665 ] INFO : Connecting to 172.16.1.4(172.16.1.4):2181, use_ssl: False (connection.py:650, _connect) 2025-04-02 03:24:04 [ 665 ] WARNING : Connection dropped: socket connection error: Connection refused (connection.py:622, _connect_attempt) 2025-04-02 03:24:04 [ 665 ] INFO : Connecting to 172.16.1.4(172.16.1.4):2181, use_ssl: False (connection.py:650, _connect) 2025-04-02 03:24:04 [ 665 ] WARNING : Connection dropped: socket connection error: Connection refused (connection.py:622, _connect_attempt) 2025-04-02 03:24:05 [ 665 ] INFO : Connecting to 172.16.1.4(172.16.1.4):2181, use_ssl: False (connection.py:650, _connect) 2025-04-02 03:24:05 [ 665 ] WARNING : Connection dropped: socket connection error: Connection refused (connection.py:622, _connect_attempt) 2025-04-02 03:24:07 [ 665 ] INFO : Connecting to 172.16.1.4(172.16.1.4):2181, use_ssl: False (connection.py:650, _connect) 2025-04-02 03:24:07 [ 665 ] DEBUG : Sending request(xid=None): Connect(protocol_version=0, last_zxid_seen=0, time_out=30000, session_id=0, passwd=b'\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00', read_only=None) (connection.py:312, _submit) 2025-04-02 03:24:07 [ 665 ] INFO : Zookeeper connection established, state: CONNECTED (client.py:532, _session_callback) 2025-04-02 03:24:07 [ 665 ] DEBUG : Sending request(xid=1): GetChildren(path='/', watcher=None) (connection.py:312, _submit) 2025-04-02 03:24:07 [ 665 ] DEBUG : Received response(xid=1): ['keeper'] (connection.py:410, _read_response) 2025-04-02 03:24:07 [ 665 ] DEBUG : Sending request(xid=2): Close() (connection.py:312, _submit) 2025-04-02 03:24:07 [ 665 ] WARNING : Connection dropped: socket connection broken (connection.py:622, _connect_attempt) 2025-04-02 03:24:07 [ 665 ] WARNING : Transition to CONNECTING (connection.py:626, _connect_attempt) 2025-04-02 03:24:07 [ 665 ] INFO : Zookeeper connection lost (client.py:543, _session_callback) 2025-04-02 03:24:07 [ 665 ] WARNING : Failed connecting to Zookeeper within the connection retry policy. (connection.py:515, zk_loop) 2025-04-02 03:24:07 [ 665 ] INFO : Zookeeper session closed, state: CLOSED (client.py:537, _session_callback) 2025-04-02 03:24:07 [ 665 ] DEBUG : get_instance_ip instance_name=zoo2 (cluster.py:2004, get_instance_ip) 2025-04-02 03:24:07 [ 665 ] DEBUG : http://localhost:None "GET /v1.46/containers/roottestmasksensitiveinfo-zoo2-1/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-04-02 03:24:07 [ 665 ] DEBUG : get_kazoo_client: zoo2, ip:172.16.1.3, port:2181, use_ssl:False (cluster.py:3223, get_kazoo_client) 2025-04-02 03:24:07 [ 665 ] INFO : Connecting to 172.16.1.3(172.16.1.3):2181, use_ssl: False (connection.py:650, _connect) 2025-04-02 03:24:07 [ 665 ] DEBUG : Sending request(xid=None): Connect(protocol_version=0, last_zxid_seen=0, time_out=30000, session_id=0, passwd=b'\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00', read_only=None) (connection.py:312, _submit) 2025-04-02 03:24:07 [ 665 ] INFO : Zookeeper connection established, state: CONNECTED (client.py:532, _session_callback) 2025-04-02 03:24:07 [ 665 ] DEBUG : Sending request(xid=1): GetChildren(path='/', watcher=None) (connection.py:312, _submit) 2025-04-02 03:24:07 [ 665 ] DEBUG : Received response(xid=1): ['keeper'] (connection.py:410, _read_response) 2025-04-02 03:24:07 [ 665 ] DEBUG : Sending request(xid=2): Close() (connection.py:312, _submit) 2025-04-02 03:24:07 [ 665 ] WARNING : Connection dropped: socket connection broken (connection.py:622, _connect_attempt) 2025-04-02 03:24:07 [ 665 ] WARNING : Transition to CONNECTING (connection.py:626, _connect_attempt) 2025-04-02 03:24:07 [ 665 ] INFO : Zookeeper connection lost (client.py:543, _session_callback) 2025-04-02 03:24:07 [ 665 ] WARNING : Failed connecting to Zookeeper within the connection retry policy. (connection.py:515, zk_loop) 2025-04-02 03:24:07 [ 665 ] INFO : Zookeeper session closed, state: CLOSED (client.py:537, _session_callback) 2025-04-02 03:24:07 [ 665 ] DEBUG : get_instance_ip instance_name=zoo3 (cluster.py:2004, get_instance_ip) 2025-04-02 03:24:07 [ 665 ] DEBUG : http://localhost:None "GET /v1.46/containers/roottestmasksensitiveinfo-zoo3-1/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-04-02 03:24:07 [ 665 ] DEBUG : get_kazoo_client: zoo3, ip:172.16.1.2, port:2181, use_ssl:False (cluster.py:3223, get_kazoo_client) 2025-04-02 03:24:07 [ 665 ] INFO : Connecting to 172.16.1.2(172.16.1.2):2181, use_ssl: False (connection.py:650, _connect) 2025-04-02 03:24:07 [ 665 ] DEBUG : Sending request(xid=None): Connect(protocol_version=0, last_zxid_seen=0, time_out=30000, session_id=0, passwd=b'\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00', read_only=None) (connection.py:312, _submit) 2025-04-02 03:24:07 [ 665 ] INFO : Zookeeper connection established, state: CONNECTED (client.py:532, _session_callback) 2025-04-02 03:24:07 [ 665 ] DEBUG : Sending request(xid=1): GetChildren(path='/', watcher=None) (connection.py:312, _submit) 2025-04-02 03:24:07 [ 665 ] DEBUG : Received response(xid=1): ['keeper'] (connection.py:410, _read_response) 2025-04-02 03:24:07 [ 665 ] DEBUG : Sending request(xid=2): Close() (connection.py:312, _submit) 2025-04-02 03:24:07 [ 665 ] WARNING : Connection dropped: socket connection broken (connection.py:622, _connect_attempt) 2025-04-02 03:24:07 [ 665 ] WARNING : Transition to CONNECTING (connection.py:626, _connect_attempt) 2025-04-02 03:24:07 [ 665 ] INFO : Zookeeper connection lost (client.py:543, _session_callback) 2025-04-02 03:24:08 [ 665 ] WARNING : Failed connecting to Zookeeper within the connection retry policy. (connection.py:515, zk_loop) 2025-04-02 03:24:08 [ 665 ] INFO : Zookeeper session closed, state: CLOSED (client.py:537, _session_callback) 2025-04-02 03:24:08 [ 665 ] DEBUG : All instances of ZooKeeper started: ('zoo1', 'zoo2', 'zoo3') (cluster.py:2419, wait_zookeeper_nodes_to_start) 2025-04-02 03:24:08 [ 665 ] INFO : Trying to create Azurite instance by command docker compose --project-name roottestmasksensitiveinfo --env-file /ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/.env --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_azurite.yml --verbose up -d (cluster.py:3009, start) 2025-04-02 03:24:08 [ 665 ] DEBUG : Command:[docker compose --project-name roottestmasksensitiveinfo --env-file /ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/.env --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_azurite.yml --verbose up -d] (cluster.py:120, run_and_check) 2025-04-02 03:24:08 [ 665 ] DEBUG : Stderr:time="2025-04-02T03:24:08Z" level=trace msg="Docker Desktop integration not enabled" (cluster.py:146, run_and_check) 2025-04-02 03:24:08 [ 665 ] DEBUG : Stderr: Volume "roottestmasksensitiveinfo_data1-1" Creating (cluster.py:146, run_and_check) 2025-04-02 03:24:08 [ 665 ] DEBUG : Stderr: Volume "roottestmasksensitiveinfo_data1-1" Created (cluster.py:146, run_and_check) 2025-04-02 03:24:08 [ 665 ] DEBUG : Stderr:time="2025-04-02T03:24:08Z" level=warning msg="Found orphan containers ([roottestmasksensitiveinfo-zoo1-1 roottestmasksensitiveinfo-zoo2-1 roottestmasksensitiveinfo-zoo3-1]) for this project. If you removed or renamed this service in your compose file, you can run this command with the --remove-orphans flag to clean it up." (cluster.py:146, run_and_check) 2025-04-02 03:24:08 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-azurite1-1 Creating (cluster.py:146, run_and_check) 2025-04-02 03:24:08 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-azurite1-1 Created (cluster.py:146, run_and_check) 2025-04-02 03:24:08 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-azurite1-1 Starting (cluster.py:146, run_and_check) 2025-04-02 03:24:08 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-azurite1-1 Started (cluster.py:146, run_and_check) 2025-04-02 03:24:08 [ 665 ] DEBUG : Stderr:time="2025-04-02T03:24:08Z" level=debug msg="otel error" error="" (cluster.py:146, run_and_check) 2025-04-02 03:24:08 [ 665 ] DEBUG : Stderr:time="2025-04-02T03:24:08Z" level=debug msg="otel error" error="" (cluster.py:146, run_and_check) 2025-04-02 03:24:08 [ 665 ] INFO : Trying to connect to Azurite (cluster.py:3023, start) 2025-04-02 03:24:09 [ 665 ] INFO : Request URL: 'http://127.0.0.1:30000/devstoreaccount1/?restype=REDACTED&comp=REDACTED' Request method: 'GET' Request headers: 'x-ms-version': 'REDACTED' 'Accept': 'application/xml' 'User-Agent': 'azsdk-python-storage-blob/12.19.0 Python/3.10.12 (Linux-5.15.0-130-generic-x86_64-with-glibc2.35)' 'x-ms-date': 'REDACTED' 'x-ms-client-request-id': 'f0d2a2d6-0f71-11f0-99fc-0242ac110002' 'Authorization': 'REDACTED' No body was attached to the request (_universal.py:514, on_request) 2025-04-02 03:24:09 [ 665 ] DEBUG : Starting new HTTP connection (1): 127.0.0.1:30000 (connectionpool.py:245, _new_conn) 2025-04-02 03:24:09 [ 665 ] DEBUG : http://127.0.0.1:30000 "GET /devstoreaccount1/?restype=account&comp=properties HTTP/1.1" 200 0 (connectionpool.py:547, _make_request) 2025-04-02 03:24:09 [ 665 ] INFO : Response status: 200 Response headers: 'Server': 'Azurite-Blob/3.34.0' 'x-ms-client-request-id': 'f0d2a2d6-0f71-11f0-99fc-0242ac110002' 'x-ms-request-id': '0cb10e95-8c7e-4115-8fe5-49a303606b64' 'x-ms-version': 'REDACTED' 'date': 'Wed, 02 Apr 2025 03:24:09 GMT' 'x-ms-sku-name': 'REDACTED' 'x-ms-account-kind': 'REDACTED' 'x-ms-is-hns-enabled': 'REDACTED' 'Connection': 'keep-alive' 'Keep-Alive': 'REDACTED' 'Content-Length': '0' (_universal.py:550, on_response) 2025-04-02 03:24:09 [ 665 ] DEBUG : {'client_request_id': 'f0d2a2d6-0f71-11f0-99fc-0242ac110002', 'request_id': '0cb10e95-8c7e-4115-8fe5-49a303606b64', 'version': '2025-05-05', 'date': datetime.datetime(2025, 4, 2, 3, 24, 9, tzinfo=datetime.timezone.utc), 'sku_name': 'Standard_RAGRS', 'account_kind': 'StorageV2', 'is_hns_enabled': False} (cluster.py:2549, wait_azurite_to_start) 2025-04-02 03:24:09 [ 665 ] INFO : Request URL: 'http://127.0.0.1:30000/devstoreaccount1/?comp=REDACTED&prefix=REDACTED&include=REDACTED' Request method: 'GET' Request headers: 'x-ms-version': 'REDACTED' 'Accept': 'application/xml' 'User-Agent': 'azsdk-python-storage-blob/12.19.0 Python/3.10.12 (Linux-5.15.0-130-generic-x86_64-with-glibc2.35)' 'x-ms-date': 'REDACTED' 'x-ms-client-request-id': 'f0d805aa-0f71-11f0-99fc-0242ac110002' 'Authorization': 'REDACTED' No body was attached to the request (_universal.py:514, on_request) 2025-04-02 03:24:09 [ 665 ] DEBUG : http://127.0.0.1:30000 "GET /devstoreaccount1/?comp=list&prefix=azurite-container&include= HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-04-02 03:24:09 [ 665 ] INFO : Response status: 200 Response headers: 'Server': 'Azurite-Blob/3.34.0' 'x-ms-client-request-id': 'f0d805aa-0f71-11f0-99fc-0242ac110002' 'x-ms-request-id': '3b432543-433d-46ab-be96-45968947af3f' 'x-ms-version': 'REDACTED' 'content-type': 'application/xml' 'Date': 'Wed, 02 Apr 2025 03:24:09 GMT' 'Connection': 'keep-alive' 'Keep-Alive': 'REDACTED' 'Transfer-Encoding': 'chunked' (_universal.py:550, on_response) 2025-04-02 03:24:09 [ 665 ] INFO : Request URL: 'http://127.0.0.1:30000/devstoreaccount1/azurite-container?restype=REDACTED' Request method: 'GET' Request headers: 'x-ms-version': 'REDACTED' 'Accept': 'application/xml' 'User-Agent': 'azsdk-python-storage-blob/12.19.0 Python/3.10.12 (Linux-5.15.0-130-generic-x86_64-with-glibc2.35)' 'x-ms-date': 'REDACTED' 'x-ms-client-request-id': 'f0d9beae-0f71-11f0-99fc-0242ac110002' 'Authorization': 'REDACTED' No body was attached to the request (_universal.py:514, on_request) 2025-04-02 03:24:09 [ 665 ] DEBUG : http://127.0.0.1:30000 "GET /devstoreaccount1/azurite-container?restype=container HTTP/1.1" 404 None (connectionpool.py:547, _make_request) 2025-04-02 03:24:09 [ 665 ] INFO : Response status: 404 Response headers: 'Server': 'Azurite-Blob/3.34.0' 'x-ms-error-code': 'ContainerNotFound' 'x-ms-request-id': '73e49559-38f0-4aa1-8d86-ca618713a968' 'content-type': 'application/xml' 'Date': 'Wed, 02 Apr 2025 03:24:09 GMT' 'Connection': 'keep-alive' 'Keep-Alive': 'REDACTED' 'Transfer-Encoding': 'chunked' (_universal.py:550, on_response) 2025-04-02 03:24:09 [ 665 ] DEBUG : azurite container 'azurite-container' doesn't exist, creating it (cluster.py:2571, wait_azurite_to_start) 2025-04-02 03:24:09 [ 665 ] INFO : Request URL: 'http://127.0.0.1:30000/devstoreaccount1/azurite-container?restype=REDACTED' Request method: 'PUT' Request headers: 'x-ms-version': 'REDACTED' 'Accept': 'application/xml' 'User-Agent': 'azsdk-python-storage-blob/12.19.0 Python/3.10.12 (Linux-5.15.0-130-generic-x86_64-with-glibc2.35)' 'x-ms-date': 'REDACTED' 'x-ms-client-request-id': 'f0db1e0c-0f71-11f0-99fc-0242ac110002' 'Authorization': 'REDACTED' No body was attached to the request (_universal.py:514, on_request) 2025-04-02 03:24:09 [ 665 ] DEBUG : http://127.0.0.1:30000 "PUT /devstoreaccount1/azurite-container?restype=container HTTP/1.1" 201 0 (connectionpool.py:547, _make_request) 2025-04-02 03:24:09 [ 665 ] INFO : Response status: 201 Response headers: 'Server': 'Azurite-Blob/3.34.0' 'etag': '"0x1CD7E794D56D800"' 'last-modified': 'Wed, 02 Apr 2025 03:24:09 GMT' 'x-ms-client-request-id': 'f0db1e0c-0f71-11f0-99fc-0242ac110002' 'x-ms-request-id': '6b2d6fe1-e1c9-4795-a2c0-2fff58d7843a' 'x-ms-version': 'REDACTED' 'Date': 'Wed, 02 Apr 2025 03:24:09 GMT' 'Connection': 'keep-alive' 'Keep-Alive': 'REDACTED' 'Content-Length': '0' (_universal.py:550, on_response) 2025-04-02 03:24:09 [ 665 ] DEBUG : ('Trying to create ClickHouse instance by command %s', 'docker compose --env-file /ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/.env --project-name roottestmasksensitiveinfo --file /ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/node/docker-compose.yml --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_keeper.yml --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_azurite.yml up -d --no-recreate') (cluster.py:3066, start) 2025-04-02 03:24:09 [ 665 ] DEBUG : Command:[docker compose --env-file /ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/.env --project-name roottestmasksensitiveinfo --file /ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/node/docker-compose.yml --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_keeper.yml --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_azurite.yml up -d --no-recreate] (cluster.py:120, run_and_check) 2025-04-02 03:24:09 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-azurite1-1 Running (cluster.py:146, run_and_check) 2025-04-02 03:24:09 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-zoo1-1 Running (cluster.py:146, run_and_check) 2025-04-02 03:24:09 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-zoo2-1 Running (cluster.py:146, run_and_check) 2025-04-02 03:24:09 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-zoo3-1 Running (cluster.py:146, run_and_check) 2025-04-02 03:24:09 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-node-1 Creating (cluster.py:146, run_and_check) 2025-04-02 03:24:09 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-node-1 Created (cluster.py:146, run_and_check) 2025-04-02 03:24:09 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-node-1 Starting (cluster.py:146, run_and_check) 2025-04-02 03:24:09 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-node-1 Started (cluster.py:146, run_and_check) 2025-04-02 03:24:09 [ 665 ] DEBUG : ClickHouse instance created (cluster.py:3074, start) 2025-04-02 03:24:09 [ 665 ] DEBUG : get_instance_ip instance_name=node (cluster.py:2004, get_instance_ip) 2025-04-02 03:24:09 [ 665 ] DEBUG : http://localhost:None "GET /v1.46/containers/roottestmasksensitiveinfo-node-1/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-04-02 03:24:09 [ 665 ] DEBUG : get_instance_ip instance_name=node (cluster.py:2014, get_instance_global_ipv6) 2025-04-02 03:24:09 [ 665 ] DEBUG : http://localhost:None "GET /v1.46/containers/roottestmasksensitiveinfo-node-1/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-04-02 03:24:09 [ 665 ] DEBUG : Waiting for ClickHouse start in node, ip: 172.16.1.6... (cluster.py:3082, start) 2025-04-02 03:24:09 [ 665 ] DEBUG : http://localhost:None "GET /v1.46/containers/roottestmasksensitiveinfo-node-1/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-04-02 03:24:09 [ 665 ] DEBUG : http://localhost:None "GET /v1.46/containers/780f79a96275faf435132792c490ac7f80827ab4daa4f90e7a387e1e08627c74/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-04-02 03:24:09 [ 665 ] DEBUG : http://localhost:None "GET /v1.46/containers/780f79a96275faf435132792c490ac7f80827ab4daa4f90e7a387e1e08627c74/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-04-02 03:24:10 [ 665 ] DEBUG : http://localhost:None "GET /v1.46/containers/780f79a96275faf435132792c490ac7f80827ab4daa4f90e7a387e1e08627c74/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-04-02 03:24:10 [ 665 ] DEBUG : http://localhost:None "GET /v1.46/containers/780f79a96275faf435132792c490ac7f80827ab4daa4f90e7a387e1e08627c74/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-04-02 03:24:10 [ 665 ] DEBUG : http://localhost:None "GET /v1.46/containers/780f79a96275faf435132792c490ac7f80827ab4daa4f90e7a387e1e08627c74/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-04-02 03:24:10 [ 665 ] DEBUG : ClickHouse node started (cluster.py:3086, start) ------------------------------ Captured log call ------------------------------- 2025-04-02 03:24:10 [ 665 ] DEBUG : Executing query CREATE TABLE table0 (x int) ENGINE = MySQL('mysql80:3306', 'mysql_db', 'mysql_table', 'mysql_user', 'I2TIDFZV9JPX8XSX') on node (cluster.py:3564, query) 2025-04-02 03:24:10 [ 665 ] DEBUG : Executing query CREATE TABLE table1 (x int) ENGINE = PostgreSQL('postgres1:5432', 'postgres_db', 'postgres_table', 'postgres_user', 'I2TIDFZV9JPX8XSX') on node (cluster.py:3564, query) 2025-04-02 03:24:10 [ 665 ] DEBUG : Executing query CREATE TABLE table2 (x int) ENGINE = MongoDB('mongo1:27017', 'mongo_db', 'mongo_col', 'mongo_user', 'I2TIDFZV9JPX8XSX') on node (cluster.py:3564, query) 2025-04-02 03:24:10 [ 665 ] DEBUG : Executing query CREATE TABLE table3 (x int) ENGINE = S3('http://minio1:9001/root/data/test1.csv') on node (cluster.py:3564, query) 2025-04-02 03:24:10 [ 665 ] DEBUG : Executing query CREATE TABLE table4 (x int) ENGINE = S3('http://minio1:9001/root/data/test2.csv', 'CSV') on node (cluster.py:3564, query) 2025-04-02 03:24:10 [ 665 ] DEBUG : Executing query CREATE TABLE table5 (x int) ENGINE = S3('http://minio1:9001/root/data/test3.csv.gz', 'CSV', 'gzip') on node (cluster.py:3564, query) 2025-04-02 03:24:10 [ 665 ] DEBUG : Executing query CREATE TABLE table6 (x int) ENGINE = S3('http://minio1:9001/root/data/test4.csv', 'minio', 'I2TIDFZV9JPX8XSX', 'CSV') on node (cluster.py:3564, query) 2025-04-02 03:24:10 [ 665 ] DEBUG : Executing query CREATE TABLE table7 (x int) ENGINE = S3('http://minio1:9001/root/data/test5.csv.gz', 'minio', 'I2TIDFZV9JPX8XSX', 'CSV', 'gzip') on node (cluster.py:3564, query) 2025-04-02 03:24:10 [ 665 ] DEBUG : Executing query CREATE TABLE table8 (x int) ENGINE = MySQL(named_collection_1, host = 'mysql80', port = 3306, database = 'mysql_db', table = 'mysql_table', user = 'mysql_user', password = 'I2TIDFZV9JPX8XSX') on node (cluster.py:3564, query) 2025-04-02 03:24:10 [ 665 ] DEBUG : Executing query CREATE TABLE table9 (x int) ENGINE = MySQL(named_collection_2, database = 'mysql_db', host = 'mysql80', port = 3306, password = 'I2TIDFZV9JPX8XSX', table = 'mysql_table', user = 'mysql_user') on node (cluster.py:3564, query) 2025-04-02 03:24:10 [ 665 ] DEBUG : Executing query CREATE TABLE table10 (x int) ENGINE = MySQL(named_collection_3, database = 'mysql_db', host = 'mysql80', port = 3306, table = 'mysql_table') on node (cluster.py:3564, query) 2025-04-02 03:24:10 [ 665 ] DEBUG : Executing query CREATE TABLE table11 (x int) ENGINE = PostgreSQL(named_collection_4, host = 'postgres1', port = 5432, database = 'postgres_db', table = 'postgres_table', user = 'postgres_user', password = 'I2TIDFZV9JPX8XSX') on node (cluster.py:3564, query) 2025-04-02 03:24:11 [ 665 ] DEBUG : Executing query CREATE TABLE table12 (x int) ENGINE = MongoDB(named_collection_5, host = 'mongo1', port = 5432, database = 'mongo_db', collection = 'mongo_col', user = 'mongo_user', password = 'I2TIDFZV9JPX8XSX') on node (cluster.py:3564, query) 2025-04-02 03:24:11 [ 665 ] DEBUG : Executing query CREATE TABLE table13 (x int) ENGINE = S3(named_collection_6, url = 'http://minio1:9001/root/data/test8.csv', access_key_id = 'minio', secret_access_key = 'I2TIDFZV9JPX8XSX', format = 'CSV') on node (cluster.py:3564, query) 2025-04-02 03:24:11 [ 665 ] DEBUG : Executing query CREATE TABLE table14 (x int) ENGINE = S3('http://minio1:9001/root/data/test9.csv.gz', 'NOSIGN', 'CSV', 'gzip') on node (cluster.py:3564, query) 2025-04-02 03:24:11 [ 665 ] DEBUG : Executing query CREATE TABLE table15 (x int) ENGINE = S3('http://minio1:9001/root/data/test10.csv.gz', 'minio', 'I2TIDFZV9JPX8XSX') on node (cluster.py:3564, query) 2025-04-02 03:24:11 [ 665 ] DEBUG : Executing query CREATE TABLE table16 (x int) ENGINE = DeltaLake('http://minio1:9001/root/data/test11.csv.gz', 'minio', 'I2TIDFZV9JPX8XSX') on node (cluster.py:3647, query_and_get_error) _____________________________ test_table_functions _____________________________ def test_table_functions(): password = new_password() azure_conn_string = cluster.env_variables["AZURITE_CONNECTION_STRING"] account_key_pattern = re.compile("AccountKey=.*?(;|$)") masked_azure_conn_string = re.sub( account_key_pattern, "AccountKey=[HIDDEN]\\1", azure_conn_string ) azure_storage_account_url = cluster.env_variables["AZURITE_STORAGE_ACCOUNT_URL"] azure_account_name = "devstoreaccount1" azure_account_key = "Eby8vdM02xNOcqFlqUwJPLlmEtlCDXJ1OUzFT50uSRZ6IFsuFq2UVErCz4I6tq/K1SZFPTOtr/KBHBeksoGMGw==" table_functions = [ f"mysql('mysql80:3306', 'mysql_db', 'mysql_table', 'mysql_user', '{password}')", f"postgresql('postgres1:5432', 'postgres_db', 'postgres_table', 'postgres_user', '{password}')", f"mongodb('mongo1:27017', 'mongo_db', 'mongo_col', 'mongo_user', '{password}', 'x int')", f"s3('http://minio1:9001/root/data/test1.csv')", f"s3('http://minio1:9001/root/data/test2.csv', 'CSV')", f"s3('http://minio1:9001/root/data/test3.csv', 'minio', '{password}')", f"s3('http://minio1:9001/root/data/test4.csv', 'CSV', 'x int')", f"s3('http://minio1:9001/root/data/test5.csv.gz', 'CSV', 'x int', 'gzip')", f"s3('http://minio1:9001/root/data/test6.csv', 'minio', '{password}', 'CSV')", f"s3('http://minio1:9001/root/data/test7.csv', 'minio', '{password}', 'CSV', 'x int')", f"s3('http://minio1:9001/root/data/test8.csv.gz', 'minio', '{password}', 'CSV', 'x int', 'gzip')", f"remote('127.{{2..11}}', default.remote_table)", f"remote('127.{{2..11}}', default.remote_table, rand())", f"remote('127.{{2..11}}', default.remote_table, 'remote_user')", f"remote('127.{{2..11}}', default.remote_table, 'remote_user', '{password}')", f"remote('127.{{2..11}}', default.remote_table, 'remote_user', rand())", f"remote('127.{{2..11}}', default.remote_table, 'remote_user', '{password}', rand())", f"remote('127.{{2..11}}', 'default.remote_table', 'remote_user', '{password}', rand())", f"remote('127.{{2..11}}', 'default', 'remote_table', 'remote_user', '{password}', rand())", f"remote('127.{{2..11}}', numbers(10), 'remote_user', '{password}', rand())", f"remoteSecure('127.{{2..11}}', 'default', 'remote_table', 'remote_user', '{password}')", f"remoteSecure('127.{{2..11}}', 'default', 'remote_table', 'remote_user', rand())", f"mysql(named_collection_1, host = 'mysql80', port = 3306, database = 'mysql_db', table = 'mysql_table', user = 'mysql_user', password = '{password}')", f"postgresql(named_collection_2, password = '{password}', host = 'postgres1', port = 5432, database = 'postgres_db', table = 'postgres_table', user = 'postgres_user')", f"s3(named_collection_2, url = 'http://minio1:9001/root/data/test4.csv', access_key_id = 'minio', secret_access_key = '{password}')", f"remote(named_collection_6, addresses_expr = '127.{{2..11}}', database = 'default', table = 'remote_table', user = 'remote_user', password = '{password}', sharding_key = rand())", f"remoteSecure(named_collection_6, addresses_expr = '127.{{2..11}}', database = 'default', table = 'remote_table', user = 'remote_user', password = '{password}')", f"s3('http://minio1:9001/root/data/test9.csv.gz', 'NOSIGN', 'CSV')", f"s3('http://minio1:9001/root/data/test10.csv.gz', 'minio', '{password}')", f"deltaLake('http://minio1:9001/root/data/test11.csv.gz', 'minio', '{password}')", f"azureBlobStorage('{azure_conn_string}', 'cont', 'test_simple.csv', 'CSV')", f"azureBlobStorage('{azure_conn_string}', 'cont', 'test_simple_1.csv', 'CSV', 'none')", f"azureBlobStorage('{azure_conn_string}', 'cont', 'test_simple_2.csv', 'CSV', 'none', 'auto')", f"azureBlobStorage('{azure_storage_account_url}', 'cont', 'test_simple_3.csv', '{azure_account_name}', '{azure_account_key}')", f"azureBlobStorage('{azure_storage_account_url}', 'cont', 'test_simple_4.csv', '{azure_account_name}', '{azure_account_key}', 'CSV')", f"azureBlobStorage('{azure_storage_account_url}', 'cont', 'test_simple_5.csv', '{azure_account_name}', '{azure_account_key}', 'CSV', 'none')", f"azureBlobStorage('{azure_storage_account_url}', 'cont', 'test_simple_6.csv', '{azure_account_name}', '{azure_account_key}', 'CSV', 'none', 'auto')", f"azureBlobStorage(named_collection_2, connection_string = '{azure_conn_string}', container = 'cont', blob_path = 'test_simple_7.csv', format = 'CSV')", f"azureBlobStorage(named_collection_2, storage_account_url = '{azure_storage_account_url}', container = 'cont', blob_path = 'test_simple_8.csv', account_name = '{azure_account_name}', account_key = '{azure_account_key}')", f"iceberg('http://minio1:9001/root/data/test11.csv.gz', 'minio', '{password}')", f"gcs('http://minio1:9001/root/data/test11.csv.gz', 'minio', '{password}')", f"icebergS3('http://minio1:9001/root/data/test11.csv.gz', 'minio', '{password}')", f"icebergAzure('{azure_storage_account_url}', 'cont', 'test_simple_6.csv', '{azure_account_name}', '{azure_account_key}', 'CSV', 'none', 'auto')", ] def make_test_case(i): table_name = f"tablefunc{i}" table_function = table_functions[i] error = None if isinstance(table_function, tuple): table_function, error = table_function query = f"CREATE TABLE {table_name} (x int) AS {table_function}" return table_name, query, error # Generate test cases as a list of tuples (table_name, query, error). test_cases = [make_test_case(i) for i in range(len(table_functions))] for table_name, query, error in test_cases: > node.query(query) test_mask_sensitive_info/test.py:484: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ helpers/cluster.py:3565: in query return self.client.query( helpers/client.py:39: in wrap return func(self, *args, **kwargs) helpers/client.py:79: in query ).get_answer() _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = def get_answer(self): self.process.wait(timeout=DEFAULT_QUERY_TIMEOUT) self.stdout_file.seek(0) self.stderr_file.seek(0) stdout = self.stdout_file.read().decode("utf-8", errors="replace") stderr = self.stderr_file.read().decode("utf-8", errors="replace") if ( self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error ): logging.debug(f"Timed out. Last stdout:{stdout}, stderr:{stderr}") raise QueryTimeoutExceedException("Client timed out!") if ( self.process.returncode != 0 or self.remove_trash_from_stderr(stderr) ) and not self.ignore_error: > raise QueryRuntimeException( "Client failed! Return code: {}, stderr: {}".format( self.process.returncode, stderr ), self.process.returncode, stderr, ) E helpers.client.QueryRuntimeException: Client failed! Return code: 46, stderr: Received exception from server (version 25.2.2): E Code: 46. DB::Exception: Received from 172.16.1.6:9000. DB::Exception: Unknown table function deltaLake. Stack trace: E E 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000cfb8fbb E 1. DB::Exception::Exception(PreformattedMessage&&, int) @ 0x0000000007ff830c E 2. DB::Exception::Exception(int, FormatStringHelperImpl::type>, String const&) @ 0x0000000008888d8b E 3. DB::TableFunctionFactory::get(std::shared_ptr const&, std::shared_ptr) const @ 0x000000000f81b308 E 4. DB::InterpreterCreateQuery::doCreateTable(DB::ASTCreateQuery&, DB::InterpreterCreateQuery::TableProperties const&, std::unique_ptr>&, DB::LoadingStrictnessLevel) @ 0x0000000010f931e0 E 5. DB::InterpreterCreateQuery::createTable(DB::ASTCreateQuery&) @ 0x0000000010f886a2 E 6. DB::InterpreterCreateQuery::execute() @ 0x0000000010f9b6d8 E 7. DB::executeQueryImpl(char const*, char const*, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*, std::shared_ptr&) @ 0x00000000113d6b42 E 8. DB::executeQuery(String const&, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x00000000113d1d04 E 9. DB::TCPHandler::runImpl() @ 0x000000001270804c E 10. DB::TCPHandler::run() @ 0x00000000127264d9 E 11. Poco::Net::TCPServerConnection::start() @ 0x0000000015dda567 E 12. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015dda9b9 E 13. Poco::PooledThread::run() @ 0x0000000015da6d3b E 14. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015da521d E 15. ? @ 0x00007f479b080ac3 E 16. ? @ 0x00007f479b112850 E . (UNKNOWN_FUNCTION) E (query: CREATE TABLE tablefunc29 (x int) AS deltaLake('http://minio1:9001/root/data/test11.csv.gz', 'minio', 'M200WYCGB273R5X5')) helpers/client.py:248: QueryRuntimeException ------------------------------ Captured log call ------------------------------- 2025-04-02 03:24:11 [ 665 ] DEBUG : Executing query CREATE TABLE tablefunc0 (x int) AS mysql('mysql80:3306', 'mysql_db', 'mysql_table', 'mysql_user', 'M200WYCGB273R5X5') on node (cluster.py:3564, query) 2025-04-02 03:24:11 [ 665 ] DEBUG : Executing query CREATE TABLE tablefunc1 (x int) AS postgresql('postgres1:5432', 'postgres_db', 'postgres_table', 'postgres_user', 'M200WYCGB273R5X5') on node (cluster.py:3564, query) 2025-04-02 03:24:11 [ 665 ] DEBUG : Executing query CREATE TABLE tablefunc2 (x int) AS mongodb('mongo1:27017', 'mongo_db', 'mongo_col', 'mongo_user', 'M200WYCGB273R5X5', 'x int') on node (cluster.py:3564, query) 2025-04-02 03:24:11 [ 665 ] DEBUG : Executing query CREATE TABLE tablefunc3 (x int) AS s3('http://minio1:9001/root/data/test1.csv') on node (cluster.py:3564, query) 2025-04-02 03:24:11 [ 665 ] DEBUG : Executing query CREATE TABLE tablefunc4 (x int) AS s3('http://minio1:9001/root/data/test2.csv', 'CSV') on node (cluster.py:3564, query) 2025-04-02 03:24:11 [ 665 ] DEBUG : Executing query CREATE TABLE tablefunc5 (x int) AS s3('http://minio1:9001/root/data/test3.csv', 'minio', 'M200WYCGB273R5X5') on node (cluster.py:3564, query) 2025-04-02 03:24:11 [ 665 ] DEBUG : Executing query CREATE TABLE tablefunc6 (x int) AS s3('http://minio1:9001/root/data/test4.csv', 'CSV', 'x int') on node (cluster.py:3564, query) 2025-04-02 03:24:11 [ 665 ] DEBUG : Executing query CREATE TABLE tablefunc7 (x int) AS s3('http://minio1:9001/root/data/test5.csv.gz', 'CSV', 'x int', 'gzip') on node (cluster.py:3564, query) 2025-04-02 03:24:11 [ 665 ] DEBUG : Executing query CREATE TABLE tablefunc8 (x int) AS s3('http://minio1:9001/root/data/test6.csv', 'minio', 'M200WYCGB273R5X5', 'CSV') on node (cluster.py:3564, query) 2025-04-02 03:24:11 [ 665 ] DEBUG : Executing query CREATE TABLE tablefunc9 (x int) AS s3('http://minio1:9001/root/data/test7.csv', 'minio', 'M200WYCGB273R5X5', 'CSV', 'x int') on node (cluster.py:3564, query) 2025-04-02 03:24:12 [ 665 ] DEBUG : Executing query CREATE TABLE tablefunc10 (x int) AS s3('http://minio1:9001/root/data/test8.csv.gz', 'minio', 'M200WYCGB273R5X5', 'CSV', 'x int', 'gzip') on node (cluster.py:3564, query) 2025-04-02 03:24:12 [ 665 ] DEBUG : Executing query CREATE TABLE tablefunc11 (x int) AS remote('127.{2..11}', default.remote_table) on node (cluster.py:3564, query) 2025-04-02 03:24:12 [ 665 ] DEBUG : Executing query CREATE TABLE tablefunc12 (x int) AS remote('127.{2..11}', default.remote_table, rand()) on node (cluster.py:3564, query) 2025-04-02 03:24:12 [ 665 ] DEBUG : Executing query CREATE TABLE tablefunc13 (x int) AS remote('127.{2..11}', default.remote_table, 'remote_user') on node (cluster.py:3564, query) 2025-04-02 03:24:12 [ 665 ] DEBUG : Executing query CREATE TABLE tablefunc14 (x int) AS remote('127.{2..11}', default.remote_table, 'remote_user', 'M200WYCGB273R5X5') on node (cluster.py:3564, query) 2025-04-02 03:24:12 [ 665 ] DEBUG : Executing query CREATE TABLE tablefunc15 (x int) AS remote('127.{2..11}', default.remote_table, 'remote_user', rand()) on node (cluster.py:3564, query) 2025-04-02 03:24:12 [ 665 ] DEBUG : Executing query CREATE TABLE tablefunc16 (x int) AS remote('127.{2..11}', default.remote_table, 'remote_user', 'M200WYCGB273R5X5', rand()) on node (cluster.py:3564, query) 2025-04-02 03:24:12 [ 665 ] DEBUG : Executing query CREATE TABLE tablefunc17 (x int) AS remote('127.{2..11}', 'default.remote_table', 'remote_user', 'M200WYCGB273R5X5', rand()) on node (cluster.py:3564, query) 2025-04-02 03:24:12 [ 665 ] DEBUG : Executing query CREATE TABLE tablefunc18 (x int) AS remote('127.{2..11}', 'default', 'remote_table', 'remote_user', 'M200WYCGB273R5X5', rand()) on node (cluster.py:3564, query) 2025-04-02 03:24:12 [ 665 ] DEBUG : Executing query CREATE TABLE tablefunc19 (x int) AS remote('127.{2..11}', numbers(10), 'remote_user', 'M200WYCGB273R5X5', rand()) on node (cluster.py:3564, query) 2025-04-02 03:24:12 [ 665 ] DEBUG : Executing query CREATE TABLE tablefunc20 (x int) AS remoteSecure('127.{2..11}', 'default', 'remote_table', 'remote_user', 'M200WYCGB273R5X5') on node (cluster.py:3564, query) 2025-04-02 03:24:12 [ 665 ] DEBUG : Executing query CREATE TABLE tablefunc21 (x int) AS remoteSecure('127.{2..11}', 'default', 'remote_table', 'remote_user', rand()) on node (cluster.py:3564, query) 2025-04-02 03:24:12 [ 665 ] DEBUG : Executing query CREATE TABLE tablefunc22 (x int) AS mysql(named_collection_1, host = 'mysql80', port = 3306, database = 'mysql_db', table = 'mysql_table', user = 'mysql_user', password = 'M200WYCGB273R5X5') on node (cluster.py:3564, query) 2025-04-02 03:24:12 [ 665 ] DEBUG : Executing query CREATE TABLE tablefunc23 (x int) AS postgresql(named_collection_2, password = 'M200WYCGB273R5X5', host = 'postgres1', port = 5432, database = 'postgres_db', table = 'postgres_table', user = 'postgres_user') on node (cluster.py:3564, query) 2025-04-02 03:24:12 [ 665 ] DEBUG : Executing query CREATE TABLE tablefunc24 (x int) AS s3(named_collection_2, url = 'http://minio1:9001/root/data/test4.csv', access_key_id = 'minio', secret_access_key = 'M200WYCGB273R5X5') on node (cluster.py:3564, query) 2025-04-02 03:24:13 [ 665 ] DEBUG : Executing query CREATE TABLE tablefunc25 (x int) AS remote(named_collection_6, addresses_expr = '127.{2..11}', database = 'default', table = 'remote_table', user = 'remote_user', password = 'M200WYCGB273R5X5', sharding_key = rand()) on node (cluster.py:3564, query) 2025-04-02 03:24:13 [ 665 ] DEBUG : Executing query CREATE TABLE tablefunc26 (x int) AS remoteSecure(named_collection_6, addresses_expr = '127.{2..11}', database = 'default', table = 'remote_table', user = 'remote_user', password = 'M200WYCGB273R5X5') on node (cluster.py:3564, query) 2025-04-02 03:24:13 [ 665 ] DEBUG : Executing query CREATE TABLE tablefunc27 (x int) AS s3('http://minio1:9001/root/data/test9.csv.gz', 'NOSIGN', 'CSV') on node (cluster.py:3564, query) 2025-04-02 03:24:13 [ 665 ] DEBUG : Executing query CREATE TABLE tablefunc28 (x int) AS s3('http://minio1:9001/root/data/test10.csv.gz', 'minio', 'M200WYCGB273R5X5') on node (cluster.py:3564, query) 2025-04-02 03:24:13 [ 665 ] DEBUG : Executing query CREATE TABLE tablefunc29 (x int) AS deltaLake('http://minio1:9001/root/data/test11.csv.gz', 'minio', 'M200WYCGB273R5X5') on node (cluster.py:3564, query) ---------------------------- Captured log teardown ----------------------------- 2025-04-02 03:24:13 [ 665 ] DEBUG : Command:[docker compose --env-file /ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/.env --project-name roottestmasksensitiveinfo --file /ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/node/docker-compose.yml --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_keeper.yml --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_azurite.yml stop --timeout 20] (cluster.py:120, run_and_check) 2025-04-02 03:24:29 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-node-1 Stopping (cluster.py:146, run_and_check) 2025-04-02 03:24:29 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-node-1 Stopped (cluster.py:146, run_and_check) 2025-04-02 03:24:29 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-zoo3-1 Stopping (cluster.py:146, run_and_check) 2025-04-02 03:24:29 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-azurite1-1 Stopping (cluster.py:146, run_and_check) 2025-04-02 03:24:29 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-zoo1-1 Stopping (cluster.py:146, run_and_check) 2025-04-02 03:24:29 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-zoo2-1 Stopping (cluster.py:146, run_and_check) 2025-04-02 03:24:29 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-zoo2-1 Stopped (cluster.py:146, run_and_check) 2025-04-02 03:24:29 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-zoo1-1 Stopped (cluster.py:146, run_and_check) 2025-04-02 03:24:29 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-zoo3-1 Stopped (cluster.py:146, run_and_check) 2025-04-02 03:24:29 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-azurite1-1 Stopped (cluster.py:146, run_and_check) 2025-04-02 03:24:29 [ 665 ] DEBUG : Command:[bash -c [ -f /ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/node/logs/stderr.log ] && zgrep -aH "==================" /ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/node/logs/stderr.log* | ( [ -z "" ] && cat || grep -v "$" ) || true] (cluster.py:120, run_and_check) 2025-04-02 03:24:29 [ 665 ] DEBUG : Command:[docker compose --env-file /ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/.env --project-name roottestmasksensitiveinfo --file /ClickHouse/tests/integration/test_mask_sensitive_info/_instances-2/node/docker-compose.yml --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_keeper.yml --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_azurite.yml down --volumes] (cluster.py:120, run_and_check) 2025-04-02 03:24:30 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-node-1 Stopping (cluster.py:146, run_and_check) 2025-04-02 03:24:30 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-node-1 Stopped (cluster.py:146, run_and_check) 2025-04-02 03:24:30 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-node-1 Removing (cluster.py:146, run_and_check) 2025-04-02 03:24:30 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-node-1 Removed (cluster.py:146, run_and_check) 2025-04-02 03:24:30 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-zoo3-1 Stopping (cluster.py:146, run_and_check) 2025-04-02 03:24:30 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-azurite1-1 Stopping (cluster.py:146, run_and_check) 2025-04-02 03:24:30 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-zoo2-1 Stopping (cluster.py:146, run_and_check) 2025-04-02 03:24:30 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-zoo1-1 Stopping (cluster.py:146, run_and_check) 2025-04-02 03:24:30 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-zoo3-1 Stopped (cluster.py:146, run_and_check) 2025-04-02 03:24:30 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-zoo3-1 Removing (cluster.py:146, run_and_check) 2025-04-02 03:24:30 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-zoo2-1 Stopped (cluster.py:146, run_and_check) 2025-04-02 03:24:30 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-zoo2-1 Removing (cluster.py:146, run_and_check) 2025-04-02 03:24:30 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-azurite1-1 Stopped (cluster.py:146, run_and_check) 2025-04-02 03:24:30 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-azurite1-1 Removing (cluster.py:146, run_and_check) 2025-04-02 03:24:30 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-zoo1-1 Stopped (cluster.py:146, run_and_check) 2025-04-02 03:24:30 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-zoo1-1 Removing (cluster.py:146, run_and_check) 2025-04-02 03:24:30 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-zoo1-1 Removed (cluster.py:146, run_and_check) 2025-04-02 03:24:30 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-zoo2-1 Removed (cluster.py:146, run_and_check) 2025-04-02 03:24:30 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-azurite1-1 Removed (cluster.py:146, run_and_check) 2025-04-02 03:24:30 [ 665 ] DEBUG : Stderr: Container roottestmasksensitiveinfo-zoo3-1 Removed (cluster.py:146, run_and_check) 2025-04-02 03:24:30 [ 665 ] DEBUG : Stderr: Volume roottestmasksensitiveinfo_data1-1 Removing (cluster.py:146, run_and_check) 2025-04-02 03:24:30 [ 665 ] DEBUG : Stderr: Network roottestmasksensitiveinfo_default Removing (cluster.py:146, run_and_check) 2025-04-02 03:24:30 [ 665 ] DEBUG : Stderr: Volume roottestmasksensitiveinfo_data1-1 Removed (cluster.py:146, run_and_check) 2025-04-02 03:24:30 [ 665 ] DEBUG : Stderr: Network roottestmasksensitiveinfo_default Removed (cluster.py:146, run_and_check) 2025-04-02 03:24:30 [ 665 ] DEBUG : Cleanup called (cluster.py:876, cleanup) 2025-04-02 03:24:30 [ 665 ] DEBUG : Docker networks for project roottestmasksensitiveinfo are NETWORK ID NAME DRIVER SCOPE (cluster.py:855, print_all_docker_pieces) 2025-04-02 03:24:30 [ 665 ] DEBUG : Docker containers for project roottestmasksensitiveinfo are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:863, print_all_docker_pieces) 2025-04-02 03:24:30 [ 665 ] DEBUG : Docker volumes for project roottestmasksensitiveinfo are DRIVER VOLUME NAME (cluster.py:871, print_all_docker_pieces) 2025-04-02 03:24:30 [ 665 ] DEBUG : Command:[docker container list --all --filter name='^/roottestmasksensitiveinfo-.*-1$' --format '{{.ID}}:{{.Names}}'] (cluster.py:120, run_and_check) 2025-04-02 03:24:30 [ 665 ] DEBUG : Unstopped containers: {} (cluster.py:890, cleanup) 2025-04-02 03:24:30 [ 665 ] DEBUG : No running containers for project: roottestmasksensitiveinfo (cluster.py:904, cleanup) 2025-04-02 03:24:30 [ 665 ] DEBUG : Trying to prune unused networks... (cluster.py:910, cleanup) 2025-04-02 03:24:30 [ 665 ] DEBUG : Trying to prune unused images... (cluster.py:926, cleanup) 2025-04-02 03:24:30 [ 665 ] DEBUG : Command:[docker image prune -f] (cluster.py:120, run_and_check) 2025-04-02 03:24:30 [ 665 ] DEBUG : Stdout:Total reclaimed space: 0B (cluster.py:144, run_and_check) 2025-04-02 03:24:30 [ 665 ] DEBUG : Images pruned (cluster.py:929, cleanup) 2025-04-02 03:24:30 [ 665 ] DEBUG : Trying to prune unused volumes... (cluster.py:935, cleanup) 2025-04-02 03:24:30 [ 665 ] DEBUG : Command:[docker volume ls | wc -l] (cluster.py:120, run_and_check) 2025-04-02 03:24:30 [ 665 ] DEBUG : Stdout:1 (cluster.py:144, run_and_check) 2025-04-02 03:24:30 [ 665 ] DEBUG : Volumes pruned: 1 (cluster.py:940, cleanup) ============================== slowest durations =============================== 68.22s setup test_mask_sensitive_info/test.py::test_create_table 16.91s teardown test_mask_sensitive_info/test.py::test_table_functions 1.95s call test_mask_sensitive_info/test.py::test_table_functions 1.10s call test_mask_sensitive_info/test.py::test_create_table 0.00s teardown test_mask_sensitive_info/test.py::test_create_table 0.00s setup test_mask_sensitive_info/test.py::test_table_functions =========================== short test summary info ============================ FAILED test_mask_sensitive_info/test.py::test_create_table - assert 'DNS_ERRO... FAILED test_mask_sensitive_info/test.py::test_table_functions - helpers.clien... ========================= 2 failed in 88.39s (0:01:28) ========================= Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration/./runner", line 528, in subprocess.check_call(cmd, shell=True, bufsize=0) File "/usr/lib/python3.10/subprocess.py", line 369, in check_call raise CalledProcessError(retcode, cmd) subprocess.CalledProcessError: Command 'docker run --rm --name clickhouse_integration_tests_xfw36y --privileged --dns-search='.' --memory=30709030912 --security-opt seccomp=unconfined --cap-add=SYS_PTRACE --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-odbc-bridge:/clickhouse-odbc-bridge --volume=/home/ubuntu/_work/_temp/test/build/clickhouse:/clickhouse --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-library-bridge:/clickhouse-library-bridge --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/programs/server:/clickhouse-config --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration:/ClickHouse/tests/integration --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/backupview:/ClickHouse/utils/backupview --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/grpc-client/pb2:/ClickHouse/utils/grpc-client/pb2 --volume=/run:/run/host:ro --volume=clickhouse_integration_tests_volume:/var/lib/docker -e DOCKER_DOTNET_CLIENT_TAG=11de0b29a15d -e DOCKER_HELPER_TAG=5dc43a6382f0 -e DOCKER_BASE_TAG=8b2301119731 -e DOCKER_KERBEROS_KDC_TAG=9391ecdee8d7 -e DOCKER_MYSQL_GOLANG_CLIENT_TAG=9bec2a638e6e -e DOCKER_MYSQL_JAVA_CLIENT_TAG=766bff31cfe4 -e DOCKER_MYSQL_JS_CLIENT_TAG=41ba7c2ec2a1 -e DOCKER_MYSQL_PHP_CLIENT_TAG=88be89c1e3b6 -e DOCKER_NGINX_DAV_TAG=b55ac9cd7519 -e DOCKER_POSTGRESQL_JAVA_CLIENT_TAG=a4eff5c7f4d6 -e DOCKER_PYTHON_BOTTLE_TAG=caad4729259e -e DOCKER_CLIENT_TIMEOUT=300 -e COMPOSE_HTTP_TIMEOUT=600 -e PYTHONUNBUFFERED=1 -e PYTEST_ADDOPTS=" -rfEps --run-id=2 --color=no --durations=0 test_mask_sensitive_info/test.py::test_create_table test_mask_sensitive_info/test.py::test_table_functions -vvv -ss" altinityinfra/integration-tests-runner:2165613c5fcd ' returned non-zero exit status 1.